In SQL Server 2008 (or newer), use MERGE MERGE INTO YourTable T USING other_table S ON T.id = S.id AND S.tsql = 'cool' WHEN MATCHED THEN UPDATE SET col1 ... ... <看更多>

There are quite a few ways to achieve your desired results. Undeterministic methods. (in the event that many rows in table 2 match one in table 1) UPDATE T1 ... ... <看更多>